/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : DiligentStudy

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 09/04/2018 21:32:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for business
-- ----------------------------
DROP TABLE IF EXISTS `business`;
CREATE TABLE `business` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(128) DEFAULT NULL COMMENT '用户名',
  `regnum` varchar(32) DEFAULT NULL COMMENT '注册编码',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `contact` varchar(32) DEFAULT NULL COMMENT '电话号码',
  `email` varchar(32) DEFAULT NULL COMMENT '邮箱',
  `respname` varchar(128) DEFAULT NULL COMMENT '负责人姓名',
  `respphone` varchar(32) DEFAULT NULL COMMENT '负责人电话',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for develop
-- ----------------------------
DROP TABLE IF EXISTS `develop`;
CREATE TABLE `develop` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(128) DEFAULT NULL COMMENT '用户名',
  `password` varchar(128) DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for jobbusinessinfo
-- ----------------------------
DROP TABLE IF EXISTS `jobbusinessinfo`;
CREATE TABLE `jobbusinessinfo` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `businessid` int(10) DEFAULT NULL COMMENT '商家id',
  `jobposition` varchar(256) DEFAULT NULL COMMENT '招聘岗位',
  `jobnum` int(10) DEFAULT NULL COMMENT '招聘人数',
  `salary` decimal(10,0) DEFAULT NULL COMMENT '薪资',
  `telphone` varchar(32) DEFAULT NULL COMMENT '联系方式',
  `description` varchar(1024) DEFAULT NULL COMMENT '面谈',
  `type` varchar(128) DEFAULT NULL COMMENT '兼职类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `message` varchar(1024) DEFAULT NULL,
  `userid` int(10) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(256) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `sex` varchar(128) DEFAULT NULL COMMENT '性别',
  `name` varchar(256) DEFAULT NULL COMMENT '姓名',
  `telphone` varchar(32) DEFAULT NULL COMMENT '电话号码',
  `studentid` varchar(32) DEFAULT NULL COMMENT '学号',
  `idcard` varchar(32) DEFAULT NULL COMMENT '身份证',
  `phone` varchar(32) DEFAULT NULL COMMENT '电话号码',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `type` varchar(128) DEFAULT NULL COMMENT '兼职类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'wl', '123456', '男', '王龙', '15330322415', '50010', '50010', '58994321', '1044913154', NULL);
COMMIT;

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` int(10) DEFAULT NULL COMMENT '用户id',
  `age` int(10) DEFAULT NULL COMMENT '年龄',
  `major` varchar(256) DEFAULT NULL COMMENT '专业',
  `telphone` varchar(32) DEFAULT NULL COMMENT '联系方式',
  `testresult` varchar(1024) DEFAULT NULL COMMENT '网上测试结果',
  `info` varchar(1024) DEFAULT NULL COMMENT '个人简介',
  `status` int(1) DEFAULT '0' COMMENT '状态',
  `name` varchar(128) DEFAULT NULL,
  `sex` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for userjob
-- ----------------------------
DROP TABLE IF EXISTS `userjob`;
CREATE TABLE `userjob` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userinfoid` int(10) DEFAULT NULL COMMENT '用户id',
  `jobid` int(10) DEFAULT NULL COMMENT '工作id',
  `status` int(1) DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
